{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T08:08:01.924114Z",
     "start_time": "2019-09-25T08:07:58.654457Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "\n",
    "os.chdir(r'D:\\数据\\第一联系人影响')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T08:09:57.815530Z",
     "start_time": "2019-09-25T08:09:57.422483Z"
    }
   },
   "outputs": [],
   "source": [
    "emer = pd.read_csv('emer.csv')\n",
    "order = pd.read_csv('order.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T08:10:17.684871Z",
     "start_time": "2019-09-25T08:10:17.676894Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(42114, 3)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "order.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T08:14:43.058100Z",
     "start_time": "2019-09-25T08:14:43.028177Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.85"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "num = set(order['cert'])\n",
    "over = set(order[order.status=='OPEN']['cert'])\n",
    "yuqilv_all = round(len(over)/len(num)*100,2)\n",
    "yuqilv_all"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T08:38:38.543269Z",
     "start_time": "2019-09-25T08:38:38.421598Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>记录数2</th>\n",
       "      <th>a_nbr2</th>\n",
       "      <th>c_nbr2</th>\n",
       "      <th>cert_no_ciphertext2</th>\n",
       "      <th>hzf2</th>\n",
       "      <th>pn_e12</th>\n",
       "      <th>pn_e22</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>13633606099</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>6F6E3278567A42464D4C376C6652786179595566752B65...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13796787779</td>\n",
       "      <td>13704811461</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>15942369540</td>\n",
       "      <td>13322457779</td>\n",
       "      <td>4271556C43337A6855306D44373079653663764D535067...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15840089132</td>\n",
       "      <td>15104013655</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>17602451082</td>\n",
       "      <td>15304016668</td>\n",
       "      <td>644331506934774A687874727673624644656D334F3159...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15909888387</td>\n",
       "      <td>13889172808</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>13386821991</td>\n",
       "      <td>17740046066</td>\n",
       "      <td>4E65327869672B487867484B6F7949367733355A447532...</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>15840422238</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>13591466356</td>\n",
       "      <td>17341025636</td>\n",
       "      <td>3563786446337349505931646E6859755A6A6E4F6E6965...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18842505858</td>\n",
       "      <td>15566098832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>15840375361</td>\n",
       "      <td>18141738783</td>\n",
       "      <td>4C455542735639337332764D6C6F6B67716867786F3273...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13804046058</td>\n",
       "      <td>13940456690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>18940163197</td>\n",
       "      <td>18940040789</td>\n",
       "      <td>374A5341746D5174325967623662346B4E77734C376E51...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13940380568</td>\n",
       "      <td>13032454609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>13889866927</td>\n",
       "      <td>13358873981</td>\n",
       "      <td>496F654E61395161775937415A2B4A726342666B2B5178...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13998363270</td>\n",
       "      <td>13555888809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>18940040789</td>\n",
       "      <td>18940040789</td>\n",
       "      <td>4250754C323433465261483767596166594F2F6430576E...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18940030851</td>\n",
       "      <td>13386822991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>13644009556</td>\n",
       "      <td>13358854433</td>\n",
       "      <td>42706B647768676D7250343836592B5170564A72366E4A...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18240457295</td>\n",
       "      <td>15040394917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>18102436454</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>644331506934774A687875347A6F65414F6C596D333567...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18640261182</td>\n",
       "      <td>18640472130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>19904041999</td>\n",
       "      <td>17612459705</td>\n",
       "      <td>4D7A7A393258732B7075464A635A427A704577504D5250...</td>\n",
       "      <td>JINGDONG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>13940223965</td>\n",
       "      <td>13386849133</td>\n",
       "      <td>454C5432384F68374B4534737544546A314C6D6A305673...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13478306254</td>\n",
       "      <td>18940001880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>13332415818</td>\n",
       "      <td>18102484399</td>\n",
       "      <td>464D634742553679572B6A4F2B714E4636665A78425239...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13624078412</td>\n",
       "      <td>15840240901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>15040106366</td>\n",
       "      <td>18909833662</td>\n",
       "      <td>706B6271677034577477684641686D644951705175665A...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13940502328</td>\n",
       "      <td>18641331977</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>15304029009</td>\n",
       "      <td>17612459705</td>\n",
       "      <td>35637864463373495059304856304C4A654330722B4F39...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18240233266</td>\n",
       "      <td>13909810116</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>18501003752</td>\n",
       "      <td>18909833662</td>\n",
       "      <td>59756B782F486F484B5462365270304E7A6F4559673031...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>18040030807</td>\n",
       "      <td>18102421712</td>\n",
       "      <td>5678496D376250354F4247394679757054314745716E44...</td>\n",
       "      <td>TIANCHENGRONGZU</td>\n",
       "      <td>15840361614</td>\n",
       "      <td>13304002788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>13842053865</td>\n",
       "      <td>17309873397</td>\n",
       "      <td>6F7250357947572F6E7264455273595547616272314658...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13804217495</td>\n",
       "      <td>13998233035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>18809817088</td>\n",
       "      <td>18040045115</td>\n",
       "      <td>784F6C7A3361345A34714B4B3035387A52735975744F38...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18809817099</td>\n",
       "      <td>13898893277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>13624051896</td>\n",
       "      <td>17740085963</td>\n",
       "      <td>3646554F73724C6E584F7268392F58575338752B584D57...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>17741395625</td>\n",
       "      <td>17742785946</td>\n",
       "      <td>47596679387533786672727674475952586A4176416733...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13504990689</td>\n",
       "      <td>17080464819</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>17642092850</td>\n",
       "      <td>17702403333</td>\n",
       "      <td>6851647A426C57416870556F2F624354723031454B4E4B...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15141203462</td>\n",
       "      <td>13261212784</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>19904048347</td>\n",
       "      <td>15382127203</td>\n",
       "      <td>484A2F332B2B3063685A6F7145476A5A4949496D646161...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>13840286358</td>\n",
       "      <td>15382084488</td>\n",
       "      <td>706B6271677034577477676F2F703173536E474E687A49...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18309897732</td>\n",
       "      <td>18940216091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1</td>\n",
       "      <td>13889874592</td>\n",
       "      <td>18141738783</td>\n",
       "      <td>2F776C7A694C6B4A7564346D4931664B5A5A6241376930...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13609813072</td>\n",
       "      <td>15004075255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1</td>\n",
       "      <td>13709888358</td>\n",
       "      <td>13358874546</td>\n",
       "      <td>62456C6531453168546C68504373314258514E6178704C...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13842078581</td>\n",
       "      <td>13358874546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1</td>\n",
       "      <td>13342420666</td>\n",
       "      <td>18940093336</td>\n",
       "      <td>78746142776A39595A5879565674742F742B4845494F71...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13700177006</td>\n",
       "      <td>15942264223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>18809896660</td>\n",
       "      <td>13390594313</td>\n",
       "      <td>4E55595A722F5750744A6D336D4F78566C7A4553684C33...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18698809291</td>\n",
       "      <td>13352438009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>18840083999</td>\n",
       "      <td>17702440407</td>\n",
       "      <td>4248705A6C484D6249596F506649397368632F4377646A...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13898163418</td>\n",
       "      <td>15340235781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85916</th>\n",
       "      <td>1</td>\n",
       "      <td>15502483753</td>\n",
       "      <td>18004005444</td>\n",
       "      <td>596243434467516B392B70496D2F68754E6773342F4463...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>19904026652</td>\n",
       "      <td>15124095169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85917</th>\n",
       "      <td>1</td>\n",
       "      <td>17640268303</td>\n",
       "      <td>17704240924</td>\n",
       "      <td>4D5847733367416E796958665276773775595631376D64...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85918</th>\n",
       "      <td>1</td>\n",
       "      <td>15242001646</td>\n",
       "      <td>18940062687</td>\n",
       "      <td>356378644633734950593052575147574E627543697552...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13804996278</td>\n",
       "      <td>13324677829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85919</th>\n",
       "      <td>1</td>\n",
       "      <td>13889221581</td>\n",
       "      <td>18940263668</td>\n",
       "      <td>583744443755694B6B42304539397535435268386C6B4B...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15850491116</td>\n",
       "      <td>13862911588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85920</th>\n",
       "      <td>1</td>\n",
       "      <td>13904015456</td>\n",
       "      <td>18940062687</td>\n",
       "      <td>644331506934774A6878734C737A5447516E7247763663...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13514253377</td>\n",
       "      <td>13514854600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85921</th>\n",
       "      <td>1</td>\n",
       "      <td>13082436388</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>6A3170644D387372557237764477727A422B64345A6B32...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18642378651</td>\n",
       "      <td>15064236523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85922</th>\n",
       "      <td>1</td>\n",
       "      <td>13304010540</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>496F654E613951617759344A4565334D76574967385151...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>18604000729</td>\n",
       "      <td>18512475279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85923</th>\n",
       "      <td>1</td>\n",
       "      <td>18909834783</td>\n",
       "      <td>18040054050</td>\n",
       "      <td>454C5432384F68374B4534517A37344B57546B53744351...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13591685783</td>\n",
       "      <td>18940002634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85924</th>\n",
       "      <td>1</td>\n",
       "      <td>18002400055</td>\n",
       "      <td>18940022212</td>\n",
       "      <td>7050366B71614C6F794C766134524F5455626F43535244...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18940258481</td>\n",
       "      <td>18640393125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85925</th>\n",
       "      <td>1</td>\n",
       "      <td>13940321733</td>\n",
       "      <td>18940003223</td>\n",
       "      <td>4759667938753378667271696263524E38382F772B4F63...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13940035866</td>\n",
       "      <td>13840104689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85926</th>\n",
       "      <td>1</td>\n",
       "      <td>17790947518</td>\n",
       "      <td>19904047263</td>\n",
       "      <td>36367A5073514A4569566D31716E4E4A35674E44484766...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18240390049</td>\n",
       "      <td>15944457662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85927</th>\n",
       "      <td>1</td>\n",
       "      <td>19804162678</td>\n",
       "      <td>13390130078</td>\n",
       "      <td>36497459454E774732614E52624E634171567230316D68...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13840372280</td>\n",
       "      <td>17740020890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85928</th>\n",
       "      <td>1</td>\n",
       "      <td>15502618020</td>\n",
       "      <td>15309857143</td>\n",
       "      <td>4271556C43337A6855306C2F557A6C5A7A596431674253...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18640326578</td>\n",
       "      <td>13066635105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85929</th>\n",
       "      <td>1</td>\n",
       "      <td>13504016311</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>7A3634367678343048756556326B2B4F35646E754C6972...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>17602474101</td>\n",
       "      <td>13998233035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85930</th>\n",
       "      <td>1</td>\n",
       "      <td>13304054001</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>496F654E61395161775936524266386B747376334A6978...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15004040603</td>\n",
       "      <td>17302425305</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85931</th>\n",
       "      <td>1</td>\n",
       "      <td>13314011666</td>\n",
       "      <td>13314011666</td>\n",
       "      <td>42354F72473654564A4D374D46517957734E6A61425774...</td>\n",
       "      <td>JINGDONG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85932</th>\n",
       "      <td>1</td>\n",
       "      <td>15840475310</td>\n",
       "      <td>13332424400</td>\n",
       "      <td>37357A4972574E697A2B68583154436D6D2B4D68692F31...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13194197999</td>\n",
       "      <td>13332424400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85933</th>\n",
       "      <td>1</td>\n",
       "      <td>15942058385</td>\n",
       "      <td>19990026588</td>\n",
       "      <td>7050366B71614C6F794C7436427373714F56616D313736...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13702455679</td>\n",
       "      <td>13002477543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85934</th>\n",
       "      <td>1</td>\n",
       "      <td>15840562566</td>\n",
       "      <td>13332425222</td>\n",
       "      <td>4271556C43337A6855306C6D46526D487635586D7A7851...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13904040121</td>\n",
       "      <td>18040095094</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85935</th>\n",
       "      <td>1</td>\n",
       "      <td>17702406912</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>4759667938753378667272575A776A3276424D6B6F6150...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13840361120</td>\n",
       "      <td>13940234433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85936</th>\n",
       "      <td>1</td>\n",
       "      <td>17640031298</td>\n",
       "      <td>18102452353</td>\n",
       "      <td>70336B572B474C70797948767278416F455752356A5652...</td>\n",
       "      <td>TIANCHENGRONGZU</td>\n",
       "      <td>13948248912</td>\n",
       "      <td>13478763612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85937</th>\n",
       "      <td>1</td>\n",
       "      <td>18204075921</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>313977373243513379486A4C45746D506F324C6F59316C...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>18742463903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85938</th>\n",
       "      <td>1</td>\n",
       "      <td>15840291918</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>744766746B36444332624B74626439563852423459356F...</td>\n",
       "      <td>TIANCHENGRONGZU</td>\n",
       "      <td>13488551947</td>\n",
       "      <td>13998233035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85939</th>\n",
       "      <td>1</td>\n",
       "      <td>15504007860</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>51345974442F585976412B7354427369486A4C34736966...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15309896563</td>\n",
       "      <td>17640553408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85940</th>\n",
       "      <td>1</td>\n",
       "      <td>19904024329</td>\n",
       "      <td>17742785946</td>\n",
       "      <td>706B62716770345774776A68794E577A7A654F6E677451...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15840017189</td>\n",
       "      <td>13840309000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85941</th>\n",
       "      <td>1</td>\n",
       "      <td>13080883330</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>356378644633734950593257484C432B524F584255575A...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18742463903</td>\n",
       "      <td>13998233035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85942</th>\n",
       "      <td>1</td>\n",
       "      <td>15040096752</td>\n",
       "      <td>13332424400</td>\n",
       "      <td>6851647A426C5741687057394A4E4659364A496A6F5031...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13909818790</td>\n",
       "      <td>13840562554</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85943</th>\n",
       "      <td>1</td>\n",
       "      <td>18041336933</td>\n",
       "      <td>18940107793</td>\n",
       "      <td>736B72443737563656704B69784B306D366D304E696F4E...</td>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85944</th>\n",
       "      <td>1</td>\n",
       "      <td>13309888321</td>\n",
       "      <td>18109881115</td>\n",
       "      <td>3047326D4D5979634E7654317274464B6A623767796F35...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18109888321</td>\n",
       "      <td>15309886442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85945</th>\n",
       "      <td>1</td>\n",
       "      <td>13520428553</td>\n",
       "      <td>13390130078</td>\n",
       "      <td>5373655830764F62705878553237753535577442444777...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13941045906</td>\n",
       "      <td>18641023797</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>85946 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       记录数2       a_nbr2       c_nbr2  \\\n",
       "0         1  13633606099  18940047007   \n",
       "1         1  15942369540  13322457779   \n",
       "2         1  17602451082  15304016668   \n",
       "3         1  13386821991  17740046066   \n",
       "4         1  13591466356  17341025636   \n",
       "5         1  15840375361  18141738783   \n",
       "6         1  18940163197  18940040789   \n",
       "7         1  13889866927  13358873981   \n",
       "8         1  18940040789  18940040789   \n",
       "9         1  13644009556  13358854433   \n",
       "10        1  18102436454  13386827331   \n",
       "11        1  19904041999  17612459705   \n",
       "12        1  13940223965  13386849133   \n",
       "13        1  13332415818  18102484399   \n",
       "14        1  15040106366  18909833662   \n",
       "15        1  15304029009  17612459705   \n",
       "16        1  18501003752  18909833662   \n",
       "17        1  18040030807  18102421712   \n",
       "18        1  13842053865  17309873397   \n",
       "19        1  18809817088  18040045115   \n",
       "20        1  13624051896  17740085963   \n",
       "21        1  17741395625  17742785946   \n",
       "22        1  17642092850  17702403333   \n",
       "23        1  19904048347  15382127203   \n",
       "24        1  13840286358  15382084488   \n",
       "25        1  13889874592  18141738783   \n",
       "26        1  13709888358  13358874546   \n",
       "27        1  13342420666  18940093336   \n",
       "28        1  18809896660  13390594313   \n",
       "29        1  18840083999  17702440407   \n",
       "...     ...          ...          ...   \n",
       "85916     1  15502483753  18004005444   \n",
       "85917     1  17640268303  17704240924   \n",
       "85918     1  15242001646  18940062687   \n",
       "85919     1  13889221581  18940263668   \n",
       "85920     1  13904015456  18940062687   \n",
       "85921     1  13082436388  13386827331   \n",
       "85922     1  13304010540  13386827331   \n",
       "85923     1  18909834783  18040054050   \n",
       "85924     1  18002400055  18940022212   \n",
       "85925     1  13940321733  18940003223   \n",
       "85926     1  17790947518  19904047263   \n",
       "85927     1  19804162678  13390130078   \n",
       "85928     1  15502618020  15309857143   \n",
       "85929     1  13504016311  15382118432   \n",
       "85930     1  13304054001  13386827331   \n",
       "85931     1  13314011666  13314011666   \n",
       "85932     1  15840475310  13332424400   \n",
       "85933     1  15942058385  19990026588   \n",
       "85934     1  15840562566  13332425222   \n",
       "85935     1  17702406912  13386827331   \n",
       "85936     1  17640031298  18102452353   \n",
       "85937     1  18204075921  15382118432   \n",
       "85938     1  15840291918  15382118432   \n",
       "85939     1  15504007860  18940047007   \n",
       "85940     1  19904024329  17742785946   \n",
       "85941     1  13080883330  15382118432   \n",
       "85942     1  15040096752  13332424400   \n",
       "85943     1  18041336933  18940107793   \n",
       "85944     1  13309888321  18109881115   \n",
       "85945     1  13520428553  13390130078   \n",
       "\n",
       "                                     cert_no_ciphertext2             hzf2  \\\n",
       "0      6F6E3278567A42464D4C376C6652786179595566752B65...         ZHAOLIAN   \n",
       "1      4271556C43337A6855306D44373079653663764D535067...         ZHAOLIAN   \n",
       "2      644331506934774A687874727673624644656D334F3159...         ZHAOLIAN   \n",
       "3      4E65327869672B487867484B6F7949367733355A447532...          ZHONGAN   \n",
       "4      3563786446337349505931646E6859755A6A6E4F6E6965...         ZHAOLIAN   \n",
       "5      4C455542735639337332764D6C6F6B67716867786F3273...         ZHAOLIAN   \n",
       "6      374A5341746D5174325967623662346B4E77734C376E51...         ZHAOLIAN   \n",
       "7      496F654E61395161775937415A2B4A726342666B2B5178...           WEIXIN   \n",
       "8      4250754C323433465261483767596166594F2F6430576E...         ZHAOLIAN   \n",
       "9      42706B647768676D7250343836592B5170564A72366E4A...         ZHAOLIAN   \n",
       "10     644331506934774A687875347A6F65414F6C596D333567...         ZHAOLIAN   \n",
       "11     4D7A7A393258732B7075464A635A427A704577504D5250...         JINGDONG   \n",
       "12     454C5432384F68374B4534737544546A314C6D6A305673...         ZHAOLIAN   \n",
       "13     464D634742553679572B6A4F2B714E4636665A78425239...           WEIXIN   \n",
       "14     706B6271677034577477684641686D644951705175665A...           WEIXIN   \n",
       "15     35637864463373495059304856304C4A654330722B4F39...         ZHAOLIAN   \n",
       "16     59756B782F486F484B5462365270304E7A6F4559673031...           HUABEI   \n",
       "17     5678496D376250354F4247394679757054314745716E44...  TIANCHENGRONGZU   \n",
       "18     6F7250357947572F6E7264455273595547616272314658...         ZHAOLIAN   \n",
       "19     784F6C7A3361345A34714B4B3035387A52735975744F38...         ZHAOLIAN   \n",
       "20     3646554F73724C6E584F7268392F58575338752B584D57...           HUABEI   \n",
       "21     47596679387533786672727674475952586A4176416733...         ZHAOLIAN   \n",
       "22     6851647A426C57416870556F2F624354723031454B4E4B...         ZHAOLIAN   \n",
       "23     484A2F332B2B3063685A6F7145476A5A4949496D646161...           HUABEI   \n",
       "24     706B6271677034577477676F2F703173536E474E687A49...         ZHAOLIAN   \n",
       "25     2F776C7A694C6B4A7564346D4931664B5A5A6241376930...         ZHAOLIAN   \n",
       "26     62456C6531453168546C68504373314258514E6178704C...         ZHAOLIAN   \n",
       "27     78746142776A39595A5879565674742F742B4845494F71...         ZHAOLIAN   \n",
       "28     4E55595A722F5750744A6D336D4F78566C7A4553684C33...         ZHAOLIAN   \n",
       "29     4248705A6C484D6249596F506649397368632F4377646A...         ZHAOLIAN   \n",
       "...                                                  ...              ...   \n",
       "85916  596243434467516B392B70496D2F68754E6773342F4463...         ZHAOLIAN   \n",
       "85917  4D5847733367416E796958665276773775595631376D64...           HUABEI   \n",
       "85918  356378644633734950593052575147574E627543697552...         ZHAOLIAN   \n",
       "85919  583744443755694B6B42304539397535435268386C6B4B...         ZHAOLIAN   \n",
       "85920  644331506934774A6878734C737A5447516E7247763663...         ZHAOLIAN   \n",
       "85921  6A3170644D387372557237764477727A422B64345A6B32...         ZHAOLIAN   \n",
       "85922  496F654E613951617759344A4565334D76574967385151...           WEIXIN   \n",
       "85923  454C5432384F68374B4534517A37344B57546B53744351...         ZHAOLIAN   \n",
       "85924  7050366B71614C6F794C766134524F5455626F43535244...         ZHAOLIAN   \n",
       "85925  4759667938753378667271696263524E38382F772B4F63...         ZHAOLIAN   \n",
       "85926  36367A5073514A4569566D31716E4E4A35674E44484766...         ZHAOLIAN   \n",
       "85927  36497459454E774732614E52624E634171567230316D68...         ZHAOLIAN   \n",
       "85928  4271556C43337A6855306C2F557A6C5A7A596431674253...         ZHAOLIAN   \n",
       "85929  7A3634367678343048756556326B2B4F35646E754C6972...         ZHAOLIAN   \n",
       "85930  496F654E61395161775936524266386B747376334A6978...         ZHAOLIAN   \n",
       "85931  42354F72473654564A4D374D46517957734E6A61425774...         JINGDONG   \n",
       "85932  37357A4972574E697A2B68583154436D6D2B4D68692F31...         ZHAOLIAN   \n",
       "85933  7050366B71614C6F794C7436427373714F56616D313736...         ZHAOLIAN   \n",
       "85934  4271556C43337A6855306C6D46526D487635586D7A7851...         ZHAOLIAN   \n",
       "85935  4759667938753378667272575A776A3276424D6B6F6150...         ZHAOLIAN   \n",
       "85936  70336B572B474C70797948767278416F455752356A5652...  TIANCHENGRONGZU   \n",
       "85937  313977373243513379486A4C45746D506F324C6F59316C...           WEIXIN   \n",
       "85938  744766746B36444332624B74626439563852423459356F...  TIANCHENGRONGZU   \n",
       "85939  51345974442F585976412B7354427369486A4C34736966...         ZHAOLIAN   \n",
       "85940  706B62716770345774776A68794E577A7A654F6E677451...         ZHAOLIAN   \n",
       "85941  356378644633734950593257484C432B524F584255575A...         ZHAOLIAN   \n",
       "85942  6851647A426C5741687057394A4E4659364A496A6F5031...         ZHAOLIAN   \n",
       "85943  736B72443737563656704B69784B306D366D304E696F4E...          BESTPAY   \n",
       "85944  3047326D4D5979634E7654317274464B6A623767796F35...         ZHAOLIAN   \n",
       "85945  5373655830764F62705878553237753535577442444777...         ZHAOLIAN   \n",
       "\n",
       "            pn_e12       pn_e22  \n",
       "0      13796787779  13704811461  \n",
       "1      15840089132  15104013655  \n",
       "2      15909888387  13889172808  \n",
       "3      15840422238          NaN  \n",
       "4      18842505858  15566098832  \n",
       "5      13804046058  13940456690  \n",
       "6      13940380568  13032454609  \n",
       "7      13998363270  13555888809  \n",
       "8      18940030851  13386822991  \n",
       "9      18240457295  15040394917  \n",
       "10     18640261182  18640472130  \n",
       "11             NaN          NaN  \n",
       "12     13478306254  18940001880  \n",
       "13     13624078412  15840240901  \n",
       "14     13940502328  18641331977  \n",
       "15     18240233266  13909810116  \n",
       "16             NaN          NaN  \n",
       "17     15840361614  13304002788  \n",
       "18     13804217495  13998233035  \n",
       "19     18809817099  13898893277  \n",
       "20             NaN          NaN  \n",
       "21     13504990689  17080464819  \n",
       "22     15141203462  13261212784  \n",
       "23             NaN          NaN  \n",
       "24     18309897732  18940216091  \n",
       "25     13609813072  15004075255  \n",
       "26     13842078581  13358874546  \n",
       "27     13700177006  15942264223  \n",
       "28     18698809291  13352438009  \n",
       "29     13898163418  15340235781  \n",
       "...            ...          ...  \n",
       "85916  19904026652  15124095169  \n",
       "85917          NaN          NaN  \n",
       "85918  13804996278  13324677829  \n",
       "85919  15850491116  13862911588  \n",
       "85920  13514253377  13514854600  \n",
       "85921  18642378651  15064236523  \n",
       "85922  18604000729  18512475279  \n",
       "85923  13591685783  18940002634  \n",
       "85924  18940258481  18640393125  \n",
       "85925  13940035866  13840104689  \n",
       "85926  18240390049  15944457662  \n",
       "85927  13840372280  17740020890  \n",
       "85928  18640326578  13066635105  \n",
       "85929  17602474101  13998233035  \n",
       "85930  15004040603  17302425305  \n",
       "85931          NaN          NaN  \n",
       "85932  13194197999  13332424400  \n",
       "85933  13702455679  13002477543  \n",
       "85934  13904040121  18040095094  \n",
       "85935  13840361120  13940234433  \n",
       "85936  13948248912  13478763612  \n",
       "85937  13998233035  18742463903  \n",
       "85938  13488551947  13998233035  \n",
       "85939  15309896563  17640553408  \n",
       "85940  15840017189  13840309000  \n",
       "85941  18742463903  13998233035  \n",
       "85942  13909818790  13840562554  \n",
       "85943          NaN          NaN  \n",
       "85944  18109888321  15309886442  \n",
       "85945  13941045906  18641023797  \n",
       "\n",
       "[85946 rows x 7 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emer_2 = emer.copy()\n",
    "emer_2\n",
    "name = list(emer_2)\n",
    "# 把列名转为大写\n",
    "for n in name:\n",
    "#     print(n.upper())\n",
    "    emer_2.rename(columns={n:n+'2'},inplace=True)\n",
    "emer_2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T09:11:35.138530Z",
     "start_time": "2019-09-25T09:11:35.087667Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "记录数2                    int64\n",
       "a_nbr2                 object\n",
       "c_nbr2                 object\n",
       "cert_no_ciphertext2    object\n",
       "hzf2                   object\n",
       "pn_e12                 object\n",
       "pn_e22                 object\n",
       "dtype: object"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emer['a_nbr']=emer['a_nbr'].astype('str')\n",
    "emer['c_nbr']=emer['c_nbr'].astype('str')\n",
    "emer_2['a_nbr2']=emer_2['a_nbr2'].astype('str')\n",
    "emer_2['c_nbr2']=emer_2['c_nbr2'].astype('str')\n",
    "emer_2.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-09-25T09:11:44.938500Z",
     "start_time": "2019-09-25T09:11:44.712110Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>记录数</th>\n",
       "      <th>a_nbr</th>\n",
       "      <th>c_nbr</th>\n",
       "      <th>cert_no_ciphertext</th>\n",
       "      <th>hzf</th>\n",
       "      <th>pn_e1</th>\n",
       "      <th>pn_e2</th>\n",
       "      <th>记录数2</th>\n",
       "      <th>a_nbr2</th>\n",
       "      <th>c_nbr2</th>\n",
       "      <th>cert_no_ciphertext2</th>\n",
       "      <th>hzf2</th>\n",
       "      <th>pn_e12</th>\n",
       "      <th>pn_e22</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>13633606099</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>6F6E3278567A42464D4C376C6652786179595566752B65...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13796787779</td>\n",
       "      <td>13704811461</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>15942369540</td>\n",
       "      <td>13322457779</td>\n",
       "      <td>4271556C43337A6855306D44373079653663764D535067...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15840089132</td>\n",
       "      <td>15104013655</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>17602451082</td>\n",
       "      <td>15304016668</td>\n",
       "      <td>644331506934774A687874727673624644656D334F3159...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15909888387</td>\n",
       "      <td>13889172808</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "      <td>13386821991</td>\n",
       "      <td>17740046066</td>\n",
       "      <td>4E65327869672B487867484B6F7949367733355A447532...</td>\n",
       "      <td>ZHONGAN</td>\n",
       "      <td>15840422238</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "      <td>13591466356</td>\n",
       "      <td>17341025636</td>\n",
       "      <td>3563786446337349505931646E6859755A6A6E4F6E6965...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18842505858</td>\n",
       "      <td>15566098832</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18842505858</td>\n",
       "      <td>19990026291</td>\n",
       "      <td>496F654E61395161775935595866433466472B6C775947...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13066600662</td>\n",
       "      <td>15040234847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1</td>\n",
       "      <td>15840375361</td>\n",
       "      <td>18141738783</td>\n",
       "      <td>4C455542735639337332764D6C6F6B67716867786F3273...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13804046058</td>\n",
       "      <td>13940456690</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1</td>\n",
       "      <td>18940163197</td>\n",
       "      <td>18940040789</td>\n",
       "      <td>374A5341746D5174325967623662346B4E77734C376E51...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13940380568</td>\n",
       "      <td>13032454609</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13940380568</td>\n",
       "      <td>18040054789</td>\n",
       "      <td>744766746B36444332624C546C464862587033734E7A51...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15840365818</td>\n",
       "      <td>15802449286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1</td>\n",
       "      <td>13889866927</td>\n",
       "      <td>13358873981</td>\n",
       "      <td>496F654E61395161775937415A2B4A726342666B2B5178...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13998363270</td>\n",
       "      <td>13555888809</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1</td>\n",
       "      <td>18940040789</td>\n",
       "      <td>18940040789</td>\n",
       "      <td>4250754C323433465261483767596166594F2F6430576E...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18940030851</td>\n",
       "      <td>13386822991</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1</td>\n",
       "      <td>13644009556</td>\n",
       "      <td>13358854433</td>\n",
       "      <td>42706B647768676D7250343836592B5170564A72366E4A...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18240457295</td>\n",
       "      <td>15040394917</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1</td>\n",
       "      <td>18102436454</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>644331506934774A687875347A6F65414F6C596D333567...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18640261182</td>\n",
       "      <td>18640472130</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1</td>\n",
       "      <td>19904041999</td>\n",
       "      <td>17612459705</td>\n",
       "      <td>4D7A7A393258732B7075464A635A427A704577504D5250...</td>\n",
       "      <td>JINGDONG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1</td>\n",
       "      <td>13940223965</td>\n",
       "      <td>13386849133</td>\n",
       "      <td>454C5432384F68374B4534737544546A314C6D6A305673...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13478306254</td>\n",
       "      <td>18940001880</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1</td>\n",
       "      <td>13332415818</td>\n",
       "      <td>18102484399</td>\n",
       "      <td>464D634742553679572B6A4F2B714E4636665A78425239...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13624078412</td>\n",
       "      <td>15840240901</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1</td>\n",
       "      <td>15040106366</td>\n",
       "      <td>18909833662</td>\n",
       "      <td>706B6271677034577477684641686D644951705175665A...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13940502328</td>\n",
       "      <td>18641331977</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1</td>\n",
       "      <td>15304029009</td>\n",
       "      <td>17612459705</td>\n",
       "      <td>35637864463373495059304856304C4A654330722B4F39...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18240233266</td>\n",
       "      <td>13909810116</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1</td>\n",
       "      <td>18501003752</td>\n",
       "      <td>18909833662</td>\n",
       "      <td>59756B782F486F484B5462365270304E7A6F4559673031...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1</td>\n",
       "      <td>18040030807</td>\n",
       "      <td>18102421712</td>\n",
       "      <td>5678496D376250354F4247394679757054314745716E44...</td>\n",
       "      <td>TIANCHENGRONGZU</td>\n",
       "      <td>15840361614</td>\n",
       "      <td>13304002788</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1</td>\n",
       "      <td>13842053865</td>\n",
       "      <td>17309873397</td>\n",
       "      <td>6F7250357947572F6E7264455273595547616272314658...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13804217495</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1</td>\n",
       "      <td>18809817088</td>\n",
       "      <td>18040045115</td>\n",
       "      <td>784F6C7A3361345A34714B4B3035387A52735975744F38...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18809817099</td>\n",
       "      <td>13898893277</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1</td>\n",
       "      <td>13624051896</td>\n",
       "      <td>17740085963</td>\n",
       "      <td>3646554F73724C6E584F7268392F58575338752B584D57...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1</td>\n",
       "      <td>17741395625</td>\n",
       "      <td>17742785946</td>\n",
       "      <td>47596679387533786672727674475952586A4176416733...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13504990689</td>\n",
       "      <td>17080464819</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1</td>\n",
       "      <td>17642092850</td>\n",
       "      <td>17702403333</td>\n",
       "      <td>6851647A426C57416870556F2F624354723031454B4E4B...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15141203462</td>\n",
       "      <td>13261212784</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1</td>\n",
       "      <td>19904048347</td>\n",
       "      <td>15382127203</td>\n",
       "      <td>484A2F332B2B3063685A6F7145476A5A4949496D646161...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1</td>\n",
       "      <td>13840286358</td>\n",
       "      <td>15382084488</td>\n",
       "      <td>706B6271677034577477676F2F703173536E474E687A49...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18309897732</td>\n",
       "      <td>18940216091</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1</td>\n",
       "      <td>13889874592</td>\n",
       "      <td>18141738783</td>\n",
       "      <td>2F776C7A694C6B4A7564346D4931664B5A5A6241376930...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13609813072</td>\n",
       "      <td>15004075255</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1</td>\n",
       "      <td>13709888358</td>\n",
       "      <td>13358874546</td>\n",
       "      <td>62456C6531453168546C68504373314258514E6178704C...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13842078581</td>\n",
       "      <td>13358874546</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1</td>\n",
       "      <td>13342420666</td>\n",
       "      <td>18940093336</td>\n",
       "      <td>78746142776A39595A5879565674742F742B4845494F71...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13700177006</td>\n",
       "      <td>15942264223</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1</td>\n",
       "      <td>18809896660</td>\n",
       "      <td>13390594313</td>\n",
       "      <td>4E55595A722F5750744A6D336D4F78566C7A4553684C33...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18698809291</td>\n",
       "      <td>13352438009</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1</td>\n",
       "      <td>18840083999</td>\n",
       "      <td>17702440407</td>\n",
       "      <td>4248705A6C484D6249596F506649397368632F4377646A...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13898163418</td>\n",
       "      <td>15340235781</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88601</th>\n",
       "      <td>1</td>\n",
       "      <td>17640268303</td>\n",
       "      <td>17704240924</td>\n",
       "      <td>4D5847733367416E796958665276773775595631376D64...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88602</th>\n",
       "      <td>1</td>\n",
       "      <td>15242001646</td>\n",
       "      <td>18940062687</td>\n",
       "      <td>356378644633734950593052575147574E627543697552...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13804996278</td>\n",
       "      <td>13324677829</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88603</th>\n",
       "      <td>1</td>\n",
       "      <td>13889221581</td>\n",
       "      <td>18940263668</td>\n",
       "      <td>583744443755694B6B42304539397535435268386C6B4B...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15850491116</td>\n",
       "      <td>13862911588</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88604</th>\n",
       "      <td>1</td>\n",
       "      <td>13904015456</td>\n",
       "      <td>18940062687</td>\n",
       "      <td>644331506934774A6878734C737A5447516E7247763663...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13514253377</td>\n",
       "      <td>13514854600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88605</th>\n",
       "      <td>1</td>\n",
       "      <td>13082436388</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>6A3170644D387372557237764477727A422B64345A6B32...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18642378651</td>\n",
       "      <td>15064236523</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88606</th>\n",
       "      <td>1</td>\n",
       "      <td>13304010540</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>496F654E613951617759344A4565334D76574967385151...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>18604000729</td>\n",
       "      <td>18512475279</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88607</th>\n",
       "      <td>1</td>\n",
       "      <td>18909834783</td>\n",
       "      <td>18040054050</td>\n",
       "      <td>454C5432384F68374B4534517A37344B57546B53744351...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13591685783</td>\n",
       "      <td>18940002634</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88608</th>\n",
       "      <td>1</td>\n",
       "      <td>18002400055</td>\n",
       "      <td>18940022212</td>\n",
       "      <td>7050366B71614C6F794C766134524F5455626F43535244...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18940258481</td>\n",
       "      <td>18640393125</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88609</th>\n",
       "      <td>1</td>\n",
       "      <td>13940321733</td>\n",
       "      <td>18940003223</td>\n",
       "      <td>4759667938753378667271696263524E38382F772B4F63...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13940035866</td>\n",
       "      <td>13840104689</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88610</th>\n",
       "      <td>1</td>\n",
       "      <td>17790947518</td>\n",
       "      <td>19904047263</td>\n",
       "      <td>36367A5073514A4569566D31716E4E4A35674E44484766...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18240390049</td>\n",
       "      <td>15944457662</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88611</th>\n",
       "      <td>1</td>\n",
       "      <td>19804162678</td>\n",
       "      <td>13390130078</td>\n",
       "      <td>36497459454E774732614E52624E634171567230316D68...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13840372280</td>\n",
       "      <td>17740020890</td>\n",
       "      <td>1.0</td>\n",
       "      <td>13840372280</td>\n",
       "      <td>13304005680</td>\n",
       "      <td>6C4546336D564C4F48374D337072354242764A3754566C...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>19804162678</td>\n",
       "      <td>17740020890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88612</th>\n",
       "      <td>1</td>\n",
       "      <td>15502618020</td>\n",
       "      <td>15309857143</td>\n",
       "      <td>4271556C43337A6855306C2F557A6C5A7A596431674253...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18640326578</td>\n",
       "      <td>13066635105</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88613</th>\n",
       "      <td>1</td>\n",
       "      <td>13504016311</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>7A3634367678343048756556326B2B4F35646E754C6972...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>17602474101</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88614</th>\n",
       "      <td>1</td>\n",
       "      <td>13304054001</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>496F654E61395161775936524266386B747376334A6978...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15004040603</td>\n",
       "      <td>17302425305</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88615</th>\n",
       "      <td>1</td>\n",
       "      <td>13314011666</td>\n",
       "      <td>13314011666</td>\n",
       "      <td>42354F72473654564A4D374D46517957734E6A61425774...</td>\n",
       "      <td>JINGDONG</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88616</th>\n",
       "      <td>1</td>\n",
       "      <td>15840475310</td>\n",
       "      <td>13332424400</td>\n",
       "      <td>37357A4972574E697A2B68583154436D6D2B4D68692F31...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13194197999</td>\n",
       "      <td>13332424400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88617</th>\n",
       "      <td>1</td>\n",
       "      <td>15942058385</td>\n",
       "      <td>19990026588</td>\n",
       "      <td>7050366B71614C6F794C7436427373714F56616D313736...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13702455679</td>\n",
       "      <td>13002477543</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88618</th>\n",
       "      <td>1</td>\n",
       "      <td>15840562566</td>\n",
       "      <td>13332425222</td>\n",
       "      <td>4271556C43337A6855306C6D46526D487635586D7A7851...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13904040121</td>\n",
       "      <td>18040095094</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88619</th>\n",
       "      <td>1</td>\n",
       "      <td>17702406912</td>\n",
       "      <td>13386827331</td>\n",
       "      <td>4759667938753378667272575A776A3276424D6B6F6150...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13840361120</td>\n",
       "      <td>13940234433</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88620</th>\n",
       "      <td>1</td>\n",
       "      <td>17640031298</td>\n",
       "      <td>18102452353</td>\n",
       "      <td>70336B572B474C70797948767278416F455752356A5652...</td>\n",
       "      <td>TIANCHENGRONGZU</td>\n",
       "      <td>13948248912</td>\n",
       "      <td>13478763612</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88621</th>\n",
       "      <td>1</td>\n",
       "      <td>18204075921</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>313977373243513379486A4C45746D506F324C6F59316C...</td>\n",
       "      <td>WEIXIN</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>18742463903</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88622</th>\n",
       "      <td>1</td>\n",
       "      <td>15840291918</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>744766746B36444332624B74626439563852423459356F...</td>\n",
       "      <td>TIANCHENGRONGZU</td>\n",
       "      <td>13488551947</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88623</th>\n",
       "      <td>1</td>\n",
       "      <td>15504007860</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>51345974442F585976412B7354427369486A4C34736966...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15309896563</td>\n",
       "      <td>17640553408</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15309896563</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>44614F356C6851464A7564326C2B4E6630632B4F554532...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15331981386</td>\n",
       "      <td>18240253407</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88624</th>\n",
       "      <td>1</td>\n",
       "      <td>15504007860</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>51345974442F585976412B7354427369486A4C34736966...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15309896563</td>\n",
       "      <td>17640553408</td>\n",
       "      <td>1.0</td>\n",
       "      <td>15309896563</td>\n",
       "      <td>18940047007</td>\n",
       "      <td>44614F356C6851464A7564326C2B4E6630632B4F554532...</td>\n",
       "      <td>HUABEI</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88625</th>\n",
       "      <td>1</td>\n",
       "      <td>19904024329</td>\n",
       "      <td>17742785946</td>\n",
       "      <td>706B62716770345774776A68794E577A7A654F6E677451...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>15840017189</td>\n",
       "      <td>13840309000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88626</th>\n",
       "      <td>1</td>\n",
       "      <td>13080883330</td>\n",
       "      <td>15382118432</td>\n",
       "      <td>356378644633734950593257484C432B524F584255575A...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18742463903</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18742463903</td>\n",
       "      <td>17309873397</td>\n",
       "      <td>7050366B71614C6F794C75686B39397A48797273586777...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13998233035</td>\n",
       "      <td>15040033273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88627</th>\n",
       "      <td>1</td>\n",
       "      <td>15040096752</td>\n",
       "      <td>13332424400</td>\n",
       "      <td>6851647A426C5741687057394A4E4659364A496A6F5031...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13909818790</td>\n",
       "      <td>13840562554</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88628</th>\n",
       "      <td>1</td>\n",
       "      <td>18041336933</td>\n",
       "      <td>18940107793</td>\n",
       "      <td>736B72443737563656704B69784B306D366D304E696F4E...</td>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88629</th>\n",
       "      <td>1</td>\n",
       "      <td>13309888321</td>\n",
       "      <td>18109881115</td>\n",
       "      <td>3047326D4D5979634E7654317274464B6A623767796F35...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>18109888321</td>\n",
       "      <td>15309886442</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88630</th>\n",
       "      <td>1</td>\n",
       "      <td>13520428553</td>\n",
       "      <td>13390130078</td>\n",
       "      <td>5373655830764F62705878553237753535577442444777...</td>\n",
       "      <td>ZHAOLIAN</td>\n",
       "      <td>13941045906</td>\n",
       "      <td>18641023797</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>88631 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       记录数        a_nbr        c_nbr  \\\n",
       "0        1  13633606099  18940047007   \n",
       "1        1  15942369540  13322457779   \n",
       "2        1  17602451082  15304016668   \n",
       "3        1  13386821991  17740046066   \n",
       "4        1  13591466356  17341025636   \n",
       "5        1  15840375361  18141738783   \n",
       "6        1  18940163197  18940040789   \n",
       "7        1  13889866927  13358873981   \n",
       "8        1  18940040789  18940040789   \n",
       "9        1  13644009556  13358854433   \n",
       "10       1  18102436454  13386827331   \n",
       "11       1  19904041999  17612459705   \n",
       "12       1  13940223965  13386849133   \n",
       "13       1  13332415818  18102484399   \n",
       "14       1  15040106366  18909833662   \n",
       "15       1  15304029009  17612459705   \n",
       "16       1  18501003752  18909833662   \n",
       "17       1  18040030807  18102421712   \n",
       "18       1  13842053865  17309873397   \n",
       "19       1  18809817088  18040045115   \n",
       "20       1  13624051896  17740085963   \n",
       "21       1  17741395625  17742785946   \n",
       "22       1  17642092850  17702403333   \n",
       "23       1  19904048347  15382127203   \n",
       "24       1  13840286358  15382084488   \n",
       "25       1  13889874592  18141738783   \n",
       "26       1  13709888358  13358874546   \n",
       "27       1  13342420666  18940093336   \n",
       "28       1  18809896660  13390594313   \n",
       "29       1  18840083999  17702440407   \n",
       "...    ...          ...          ...   \n",
       "88601    1  17640268303  17704240924   \n",
       "88602    1  15242001646  18940062687   \n",
       "88603    1  13889221581  18940263668   \n",
       "88604    1  13904015456  18940062687   \n",
       "88605    1  13082436388  13386827331   \n",
       "88606    1  13304010540  13386827331   \n",
       "88607    1  18909834783  18040054050   \n",
       "88608    1  18002400055  18940022212   \n",
       "88609    1  13940321733  18940003223   \n",
       "88610    1  17790947518  19904047263   \n",
       "88611    1  19804162678  13390130078   \n",
       "88612    1  15502618020  15309857143   \n",
       "88613    1  13504016311  15382118432   \n",
       "88614    1  13304054001  13386827331   \n",
       "88615    1  13314011666  13314011666   \n",
       "88616    1  15840475310  13332424400   \n",
       "88617    1  15942058385  19990026588   \n",
       "88618    1  15840562566  13332425222   \n",
       "88619    1  17702406912  13386827331   \n",
       "88620    1  17640031298  18102452353   \n",
       "88621    1  18204075921  15382118432   \n",
       "88622    1  15840291918  15382118432   \n",
       "88623    1  15504007860  18940047007   \n",
       "88624    1  15504007860  18940047007   \n",
       "88625    1  19904024329  17742785946   \n",
       "88626    1  13080883330  15382118432   \n",
       "88627    1  15040096752  13332424400   \n",
       "88628    1  18041336933  18940107793   \n",
       "88629    1  13309888321  18109881115   \n",
       "88630    1  13520428553  13390130078   \n",
       "\n",
       "                                      cert_no_ciphertext              hzf  \\\n",
       "0      6F6E3278567A42464D4C376C6652786179595566752B65...         ZHAOLIAN   \n",
       "1      4271556C43337A6855306D44373079653663764D535067...         ZHAOLIAN   \n",
       "2      644331506934774A687874727673624644656D334F3159...         ZHAOLIAN   \n",
       "3      4E65327869672B487867484B6F7949367733355A447532...          ZHONGAN   \n",
       "4      3563786446337349505931646E6859755A6A6E4F6E6965...         ZHAOLIAN   \n",
       "5      4C455542735639337332764D6C6F6B67716867786F3273...         ZHAOLIAN   \n",
       "6      374A5341746D5174325967623662346B4E77734C376E51...         ZHAOLIAN   \n",
       "7      496F654E61395161775937415A2B4A726342666B2B5178...           WEIXIN   \n",
       "8      4250754C323433465261483767596166594F2F6430576E...         ZHAOLIAN   \n",
       "9      42706B647768676D7250343836592B5170564A72366E4A...         ZHAOLIAN   \n",
       "10     644331506934774A687875347A6F65414F6C596D333567...         ZHAOLIAN   \n",
       "11     4D7A7A393258732B7075464A635A427A704577504D5250...         JINGDONG   \n",
       "12     454C5432384F68374B4534737544546A314C6D6A305673...         ZHAOLIAN   \n",
       "13     464D634742553679572B6A4F2B714E4636665A78425239...           WEIXIN   \n",
       "14     706B6271677034577477684641686D644951705175665A...           WEIXIN   \n",
       "15     35637864463373495059304856304C4A654330722B4F39...         ZHAOLIAN   \n",
       "16     59756B782F486F484B5462365270304E7A6F4559673031...           HUABEI   \n",
       "17     5678496D376250354F4247394679757054314745716E44...  TIANCHENGRONGZU   \n",
       "18     6F7250357947572F6E7264455273595547616272314658...         ZHAOLIAN   \n",
       "19     784F6C7A3361345A34714B4B3035387A52735975744F38...         ZHAOLIAN   \n",
       "20     3646554F73724C6E584F7268392F58575338752B584D57...           HUABEI   \n",
       "21     47596679387533786672727674475952586A4176416733...         ZHAOLIAN   \n",
       "22     6851647A426C57416870556F2F624354723031454B4E4B...         ZHAOLIAN   \n",
       "23     484A2F332B2B3063685A6F7145476A5A4949496D646161...           HUABEI   \n",
       "24     706B6271677034577477676F2F703173536E474E687A49...         ZHAOLIAN   \n",
       "25     2F776C7A694C6B4A7564346D4931664B5A5A6241376930...         ZHAOLIAN   \n",
       "26     62456C6531453168546C68504373314258514E6178704C...         ZHAOLIAN   \n",
       "27     78746142776A39595A5879565674742F742B4845494F71...         ZHAOLIAN   \n",
       "28     4E55595A722F5750744A6D336D4F78566C7A4553684C33...         ZHAOLIAN   \n",
       "29     4248705A6C484D6249596F506649397368632F4377646A...         ZHAOLIAN   \n",
       "...                                                  ...              ...   \n",
       "88601  4D5847733367416E796958665276773775595631376D64...           HUABEI   \n",
       "88602  356378644633734950593052575147574E627543697552...         ZHAOLIAN   \n",
       "88603  583744443755694B6B42304539397535435268386C6B4B...         ZHAOLIAN   \n",
       "88604  644331506934774A6878734C737A5447516E7247763663...         ZHAOLIAN   \n",
       "88605  6A3170644D387372557237764477727A422B64345A6B32...         ZHAOLIAN   \n",
       "88606  496F654E613951617759344A4565334D76574967385151...           WEIXIN   \n",
       "88607  454C5432384F68374B4534517A37344B57546B53744351...         ZHAOLIAN   \n",
       "88608  7050366B71614C6F794C766134524F5455626F43535244...         ZHAOLIAN   \n",
       "88609  4759667938753378667271696263524E38382F772B4F63...         ZHAOLIAN   \n",
       "88610  36367A5073514A4569566D31716E4E4A35674E44484766...         ZHAOLIAN   \n",
       "88611  36497459454E774732614E52624E634171567230316D68...         ZHAOLIAN   \n",
       "88612  4271556C43337A6855306C2F557A6C5A7A596431674253...         ZHAOLIAN   \n",
       "88613  7A3634367678343048756556326B2B4F35646E754C6972...         ZHAOLIAN   \n",
       "88614  496F654E61395161775936524266386B747376334A6978...         ZHAOLIAN   \n",
       "88615  42354F72473654564A4D374D46517957734E6A61425774...         JINGDONG   \n",
       "88616  37357A4972574E697A2B68583154436D6D2B4D68692F31...         ZHAOLIAN   \n",
       "88617  7050366B71614C6F794C7436427373714F56616D313736...         ZHAOLIAN   \n",
       "88618  4271556C43337A6855306C6D46526D487635586D7A7851...         ZHAOLIAN   \n",
       "88619  4759667938753378667272575A776A3276424D6B6F6150...         ZHAOLIAN   \n",
       "88620  70336B572B474C70797948767278416F455752356A5652...  TIANCHENGRONGZU   \n",
       "88621  313977373243513379486A4C45746D506F324C6F59316C...           WEIXIN   \n",
       "88622  744766746B36444332624B74626439563852423459356F...  TIANCHENGRONGZU   \n",
       "88623  51345974442F585976412B7354427369486A4C34736966...         ZHAOLIAN   \n",
       "88624  51345974442F585976412B7354427369486A4C34736966...         ZHAOLIAN   \n",
       "88625  706B62716770345774776A68794E577A7A654F6E677451...         ZHAOLIAN   \n",
       "88626  356378644633734950593257484C432B524F584255575A...         ZHAOLIAN   \n",
       "88627  6851647A426C5741687057394A4E4659364A496A6F5031...         ZHAOLIAN   \n",
       "88628  736B72443737563656704B69784B306D366D304E696F4E...          BESTPAY   \n",
       "88629  3047326D4D5979634E7654317274464B6A623767796F35...         ZHAOLIAN   \n",
       "88630  5373655830764F62705878553237753535577442444777...         ZHAOLIAN   \n",
       "\n",
       "             pn_e1        pn_e2  记录数2       a_nbr2       c_nbr2  \\\n",
       "0      13796787779  13704811461   NaN          NaN          NaN   \n",
       "1      15840089132  15104013655   NaN          NaN          NaN   \n",
       "2      15909888387  13889172808   NaN          NaN          NaN   \n",
       "3      15840422238          NaN   NaN          NaN          NaN   \n",
       "4      18842505858  15566098832   1.0  18842505858  19990026291   \n",
       "5      13804046058  13940456690   NaN          NaN          NaN   \n",
       "6      13940380568  13032454609   1.0  13940380568  18040054789   \n",
       "7      13998363270  13555888809   NaN          NaN          NaN   \n",
       "8      18940030851  13386822991   NaN          NaN          NaN   \n",
       "9      18240457295  15040394917   NaN          NaN          NaN   \n",
       "10     18640261182  18640472130   NaN          NaN          NaN   \n",
       "11             NaN          NaN   NaN          NaN          NaN   \n",
       "12     13478306254  18940001880   NaN          NaN          NaN   \n",
       "13     13624078412  15840240901   NaN          NaN          NaN   \n",
       "14     13940502328  18641331977   NaN          NaN          NaN   \n",
       "15     18240233266  13909810116   NaN          NaN          NaN   \n",
       "16             NaN          NaN   NaN          NaN          NaN   \n",
       "17     15840361614  13304002788   NaN          NaN          NaN   \n",
       "18     13804217495  13998233035   NaN          NaN          NaN   \n",
       "19     18809817099  13898893277   NaN          NaN          NaN   \n",
       "20             NaN          NaN   NaN          NaN          NaN   \n",
       "21     13504990689  17080464819   NaN          NaN          NaN   \n",
       "22     15141203462  13261212784   NaN          NaN          NaN   \n",
       "23             NaN          NaN   NaN          NaN          NaN   \n",
       "24     18309897732  18940216091   NaN          NaN          NaN   \n",
       "25     13609813072  15004075255   NaN          NaN          NaN   \n",
       "26     13842078581  13358874546   NaN          NaN          NaN   \n",
       "27     13700177006  15942264223   NaN          NaN          NaN   \n",
       "28     18698809291  13352438009   NaN          NaN          NaN   \n",
       "29     13898163418  15340235781   NaN          NaN          NaN   \n",
       "...            ...          ...   ...          ...          ...   \n",
       "88601          NaN          NaN   NaN          NaN          NaN   \n",
       "88602  13804996278  13324677829   NaN          NaN          NaN   \n",
       "88603  15850491116  13862911588   NaN          NaN          NaN   \n",
       "88604  13514253377  13514854600   NaN          NaN          NaN   \n",
       "88605  18642378651  15064236523   NaN          NaN          NaN   \n",
       "88606  18604000729  18512475279   NaN          NaN          NaN   \n",
       "88607  13591685783  18940002634   NaN          NaN          NaN   \n",
       "88608  18940258481  18640393125   NaN          NaN          NaN   \n",
       "88609  13940035866  13840104689   NaN          NaN          NaN   \n",
       "88610  18240390049  15944457662   NaN          NaN          NaN   \n",
       "88611  13840372280  17740020890   1.0  13840372280  13304005680   \n",
       "88612  18640326578  13066635105   NaN          NaN          NaN   \n",
       "88613  17602474101  13998233035   NaN          NaN          NaN   \n",
       "88614  15004040603  17302425305   NaN          NaN          NaN   \n",
       "88615          NaN          NaN   NaN          NaN          NaN   \n",
       "88616  13194197999  13332424400   NaN          NaN          NaN   \n",
       "88617  13702455679  13002477543   NaN          NaN          NaN   \n",
       "88618  13904040121  18040095094   NaN          NaN          NaN   \n",
       "88619  13840361120  13940234433   NaN          NaN          NaN   \n",
       "88620  13948248912  13478763612   NaN          NaN          NaN   \n",
       "88621  13998233035  18742463903   NaN          NaN          NaN   \n",
       "88622  13488551947  13998233035   NaN          NaN          NaN   \n",
       "88623  15309896563  17640553408   1.0  15309896563  18940047007   \n",
       "88624  15309896563  17640553408   1.0  15309896563  18940047007   \n",
       "88625  15840017189  13840309000   NaN          NaN          NaN   \n",
       "88626  18742463903  13998233035   1.0  18742463903  17309873397   \n",
       "88627  13909818790  13840562554   NaN          NaN          NaN   \n",
       "88628          NaN          NaN   NaN          NaN          NaN   \n",
       "88629  18109888321  15309886442   NaN          NaN          NaN   \n",
       "88630  13941045906  18641023797   NaN          NaN          NaN   \n",
       "\n",
       "                                     cert_no_ciphertext2      hzf2  \\\n",
       "0                                                    NaN       NaN   \n",
       "1                                                    NaN       NaN   \n",
       "2                                                    NaN       NaN   \n",
       "3                                                    NaN       NaN   \n",
       "4      496F654E61395161775935595866433466472B6C775947...    WEIXIN   \n",
       "5                                                    NaN       NaN   \n",
       "6      744766746B36444332624C546C464862587033734E7A51...  ZHAOLIAN   \n",
       "7                                                    NaN       NaN   \n",
       "8                                                    NaN       NaN   \n",
       "9                                                    NaN       NaN   \n",
       "10                                                   NaN       NaN   \n",
       "11                                                   NaN       NaN   \n",
       "12                                                   NaN       NaN   \n",
       "13                                                   NaN       NaN   \n",
       "14                                                   NaN       NaN   \n",
       "15                                                   NaN       NaN   \n",
       "16                                                   NaN       NaN   \n",
       "17                                                   NaN       NaN   \n",
       "18                                                   NaN       NaN   \n",
       "19                                                   NaN       NaN   \n",
       "20                                                   NaN       NaN   \n",
       "21                                                   NaN       NaN   \n",
       "22                                                   NaN       NaN   \n",
       "23                                                   NaN       NaN   \n",
       "24                                                   NaN       NaN   \n",
       "25                                                   NaN       NaN   \n",
       "26                                                   NaN       NaN   \n",
       "27                                                   NaN       NaN   \n",
       "28                                                   NaN       NaN   \n",
       "29                                                   NaN       NaN   \n",
       "...                                                  ...       ...   \n",
       "88601                                                NaN       NaN   \n",
       "88602                                                NaN       NaN   \n",
       "88603                                                NaN       NaN   \n",
       "88604                                                NaN       NaN   \n",
       "88605                                                NaN       NaN   \n",
       "88606                                                NaN       NaN   \n",
       "88607                                                NaN       NaN   \n",
       "88608                                                NaN       NaN   \n",
       "88609                                                NaN       NaN   \n",
       "88610                                                NaN       NaN   \n",
       "88611  6C4546336D564C4F48374D337072354242764A3754566C...  ZHAOLIAN   \n",
       "88612                                                NaN       NaN   \n",
       "88613                                                NaN       NaN   \n",
       "88614                                                NaN       NaN   \n",
       "88615                                                NaN       NaN   \n",
       "88616                                                NaN       NaN   \n",
       "88617                                                NaN       NaN   \n",
       "88618                                                NaN       NaN   \n",
       "88619                                                NaN       NaN   \n",
       "88620                                                NaN       NaN   \n",
       "88621                                                NaN       NaN   \n",
       "88622                                                NaN       NaN   \n",
       "88623  44614F356C6851464A7564326C2B4E6630632B4F554532...  ZHAOLIAN   \n",
       "88624  44614F356C6851464A7564326C2B4E6630632B4F554532...    HUABEI   \n",
       "88625                                                NaN       NaN   \n",
       "88626  7050366B71614C6F794C75686B39397A48797273586777...  ZHAOLIAN   \n",
       "88627                                                NaN       NaN   \n",
       "88628                                                NaN       NaN   \n",
       "88629                                                NaN       NaN   \n",
       "88630                                                NaN       NaN   \n",
       "\n",
       "            pn_e12       pn_e22  \n",
       "0              NaN          NaN  \n",
       "1              NaN          NaN  \n",
       "2              NaN          NaN  \n",
       "3              NaN          NaN  \n",
       "4      13066600662  15040234847  \n",
       "5              NaN          NaN  \n",
       "6      15840365818  15802449286  \n",
       "7              NaN          NaN  \n",
       "8              NaN          NaN  \n",
       "9              NaN          NaN  \n",
       "10             NaN          NaN  \n",
       "11             NaN          NaN  \n",
       "12             NaN          NaN  \n",
       "13             NaN          NaN  \n",
       "14             NaN          NaN  \n",
       "15             NaN          NaN  \n",
       "16             NaN          NaN  \n",
       "17             NaN          NaN  \n",
       "18             NaN          NaN  \n",
       "19             NaN          NaN  \n",
       "20             NaN          NaN  \n",
       "21             NaN          NaN  \n",
       "22             NaN          NaN  \n",
       "23             NaN          NaN  \n",
       "24             NaN          NaN  \n",
       "25             NaN          NaN  \n",
       "26             NaN          NaN  \n",
       "27             NaN          NaN  \n",
       "28             NaN          NaN  \n",
       "29             NaN          NaN  \n",
       "...            ...          ...  \n",
       "88601          NaN          NaN  \n",
       "88602          NaN          NaN  \n",
       "88603          NaN          NaN  \n",
       "88604          NaN          NaN  \n",
       "88605          NaN          NaN  \n",
       "88606          NaN          NaN  \n",
       "88607          NaN          NaN  \n",
       "88608          NaN          NaN  \n",
       "88609          NaN          NaN  \n",
       "88610          NaN          NaN  \n",
       "88611  19804162678  17740020890  \n",
       "88612          NaN          NaN  \n",
       "88613          NaN          NaN  \n",
       "88614          NaN          NaN  \n",
       "88615          NaN          NaN  \n",
       "88616          NaN          NaN  \n",
       "88617          NaN          NaN  \n",
       "88618          NaN          NaN  \n",
       "88619          NaN          NaN  \n",
       "88620          NaN          NaN  \n",
       "88621          NaN          NaN  \n",
       "88622          NaN          NaN  \n",
       "88623  15331981386  18240253407  \n",
       "88624          NaN          NaN  \n",
       "88625          NaN          NaN  \n",
       "88626  13998233035  15040033273  \n",
       "88627          NaN          NaN  \n",
       "88628          NaN          NaN  \n",
       "88629          NaN          NaN  \n",
       "88630          NaN          NaN  \n",
       "\n",
       "[88631 rows x 14 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "emer_3 = pd.merge(emer,emer_2,how='left',left_on='pn_e1',right_on='a_nbr2')\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
